<?php
$installer = $this;
$installer->startSetup();
$installer->run("
    DROP TABLE IF EXISTS {$installer->getTable('ttt_myfilter')};
    CREATE TABLE {$installer->getTable('ttt_myfilter')} (
        `filter_id` INT(10) unsigned NOT NULL auto_increment,
        `name` VARCHAR(250) NOT NULL,
        `entity` VARCHAR(250) NOT NULL,
        `filterkey` VARCHAR(250) NOT NULL,
        `filtervalue` VARCHAR(250) NOT NULL,
        `menu` BOOL NOT NULL,
      PRIMARY KEY (`filter_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
